Supported Data Fields

These data fields are used to build criteria for schedule actions.

Group

Field Name

Data Type

Possible Values

Notes

Segment

Segment Type

List

Generic, Air, Hotel, Car Rental, Train, DueOrPaid, OpenAir, ArrivalUnknown, Other RailContentHub, Cruise

 

SegmentNumber

Number (Integer)

 

Not available to Worldspan users

AssociateRemarks

Text

 

 

AirSegment

AirSegmentStatusCode

Text

 

 

AirlineCode

Text

 

 

FlightNumber

Number (Integer)

 

 

DepartureDateTime

Date Time

 

 

ArrivalDateTime

Date Time

 

 

Origincode

Text

 

 

OriginCityCode

Text

 

 

OriginCountryCode

Text

 

 

Destinationcode

Text

 

 

DestinationCityCode

Text

 

 

DestinationCountryCode

Text

 

 

OriginRegion

Text

 

 

OriginCustomRegion

Text

 

 

DestinationRegion

Text

 

 

DestinationCustomRegion

Text

 

 

OperatedBy

Text

 

For Travelport+ users only.

BookingClass

Text

 

For Travelport+ users only.

BookingFile

PhoneName

Text

 

 

EmailAddress

 

 

 

NotepadRemarks

Text

 

Available to Worldspan:

  • General Remarks (5[free text])

  • Unique Car remarks (5.C[free text])

ManualSSRStatusCode

Text

 

 

ManualSSRCode

Text

 

 

ManualSSRText

Text

 

 

DIRemarksText

Text

 

Available to Worldspan users. Type of remarks include

  • Accounting Remarks (5-CA[number]

  • Tour code (5-IT[free text]) and (5-ER[free text]

  • Invoice Remarks (5IR-[free text])

DIRemarksText

Text

 

 

DIRemarksCode

Text

 

 

ProgrammaticSSRStatusCode

Text

 

 

ProgrammaticSSRCode

Text

 

 

ProgrammaticSSRText

Text

 

 

TicketExists

Boolean

True, False

 

FullAgentSine

Text

 

 

TwoLetterAgentSine

Text

 

 

CustomerID

Text

 

 

VendorRemarks

Text

 

 

VendorCode

Text

 

 

OwningPCC

Text

 

For Travelport+ users only.

CarRentalSegment

SegmentNumberOfCars

Number (Integer)

 

 

VendorCode

Text

 

 

BaseRateAmount

Number (Double)

 

 

RateIsGuaranteed

Boolean

True, False

 

HotelSegment

StatusCode

Text

 

 

PropertyName

Text

 

 

CityCode

Text

 

 

VendorCode

Text

 

 

NumberOfRooms

Number (Integer)

 

 

NumberOfPersons

Number (Integer)

 

 

NumberOfNights

Number (Integer)

 

 

RateAmount

Number (Double)

 

 

RateIsGuaranteed

Boolean

True, False

 

RateIsEnteredByAgent

Boolean

True, False

 

OtherSegment

SegmentStatusCode

Text

 

For Worldspan, OtherSegment looks for passive segments.

SegmentSubtype

Text

 

VendorCode

Text

 

Fares

TotalAmount

Number (Double)

 

 

BaseAmount

Number (Double)

 

 

TaxAmount

Number (Double)

 

 

PlatingCarrierCode

Text

 

For Worldspan users, looks for plating carriers entered in the 4-DI field.

LastDateToTicket

Date Time

 

 

CommissionAmount

Number (Double)

 

 

CommissionPercentage

Number (Double)

 

 

Eticketable

Boolean

True, False

 

PaperTicketOnly

Boolean

True, False

 

IssueAuditCoupon

Boolean

True, False

 

TicketingAgencyPcc

Text

 

 

FareIsManual

Boolean

True, False

 

FareIsComputerGenerated

Boolean

True, False

 

FareIsGuaranteed

Boolean

True, False

 

TourCode

Text

True, False

 

FareGuaranteeCode

Text

 

 

PTC

Text

 

 

TicketDesignator

Text

 

 

FareBasis

Text

 

 

FormOfPayment

TypeOfPayment

 

List

  • S

  • CK

  • NONREF

  • MS

  • INV

  • CC

  • Cash

  • Cheque

  • NonRef

  • Miscellaneous

  • Invoice

  • CreditCard

  • GovernmentRequest

  • PseudoCash

  • CreditNonCreditCard

  • DebitCard

  • AKBons

  • PayLate

  • Exchange

  • MoneyOrder

  • TravelersCheck

  • SpecialGovernment

  • MultipleReceivable

  • UnitedCertificate

  • Freeform

  • Unknown

For Worldspan users, the available forms of payment include:

  • Unknown

  • Cash

  • Cheque

  • NonRef

  • Miscellaneous

  • Invoice

  • CreditCard

  • GovernmentRequest

  • Freeform

  • AccountsReceivable

  • Agent

  • DirectPayment

  • AgentVoucher

  • UnitedNations

FreeTextRemark

Text

 

 

InvoiceNumber

Text

 

 

TypeOfPaymentIsCash

Boolean

True, False

 

TypeOfPaymentIsCredit

Boolean

True, False

 

Passenger

FirstName

Text

 

 

LastName

Text

 

 

FrequentFlyerNumber

Text

 

For Travelport+ users only.

NameRemark

Text

 

 

PassengerType

 

List

If ADT look for adult.

If Cxx, CNN OR CHD look for child.

If INF or Ixx look for infant.

Where xx is a number.

 

NumberOfPassengers

Number (Integer)

 

 

PreviouslyIssuedTickets

HasBeenTicketed

Boolean

True, False

 

TicketNumber

Text

 

 

ElectronicTicket

Boolean

True, False

 

LastName

Text

 

 

FirstName

Text

 

 

NameRemark

Text

 

 

PassengerType

List

If ADT look for adult.

If Cxx OR CNN OR CHD look for child.

If INF or Ixx look for infant.

Where xx is a number.

 

PassengerNumber

Number (Integer)

 

 

SeatData

SeatCount

Number (Integer)

 

 

StatusCode

Text

 

 

RowNumber

Text

 

 

SeatCode

Text

 

 

Description

Text

 

 

Characteristics

Text

 

 

VendorLocator

 

 

 

RecordLocator

Text

 

For Travelport+ users only.

CreationDateTime

Date Time

 

For Travelport+ users only.

VendorCode

Text

 

For Travelport+ users only.

VendorName

Text

 

For Travelport+ users only.

ClientFile

 

 

 

 

 

ClientFileType

Text

 

For Travelport+ users only.

AgencyTitle

Text

 

For Travelport+ users only.

BusinessTitle

Text

 

For Travelport+ users only.

PersonalTitle

Text

 

For Travelport+ users only.

ClientFileIsActive

Boolean

True, False

For Travelport+ users only.

TravelPreferencesExists

Boolean

True, False

For Travelport+ users only.

ItineraryRemarks

Number

Number

 

For Travelport+ users only.